UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tFUcsOvAs9gmU+OUmbhPpL8jNMe77l55q3PoqwVFalI='
WHERE
key_id = '47578560ae2d41f54b2f2388498ee8455c4b40d18ba6037ffc924f9050c26e9d'
AND (
token = 'tFUcsOvAs9gmU+OUmbhPpL8jNMe77l55q3PoqwVFalI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)