UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7cSiBrDIxjL8xx5z5JvePtsFeybCC6r9I5EjDk2DS2Y='
WHERE
key_id = '6f4ab5db58f53a5414e4a59c06ee6138fbe98af900bfac1b2d4647f9ab2a72f4'
AND (
token = '7cSiBrDIxjL8xx5z5JvePtsFeybCC6r9I5EjDk2DS2Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)