UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VdTErA3fMlYV1u0JnVG3+/aFDzY9bZ/A7AJtFbCCpL8='
WHERE
key_id = 'acc4fa77095a249461a32f5a23b56bd2a482ee8c4c7d62a6855732c1fa47914e'
AND (
token = 'VdTErA3fMlYV1u0JnVG3+/aFDzY9bZ/A7AJtFbCCpL8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)