UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gysAvB7oqnVSfazx5Ah4VGwmbvyvuO47Y+oMan+OOy8='
WHERE
key_id = '7565d3068a8c2cdaa647749a1e838479a339a7b1812c7edf7b39e61e292a0f52'
AND (
token = 'gysAvB7oqnVSfazx5Ah4VGwmbvyvuO47Y+oMan+OOy8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)