UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1yjOvIxUJHD5qJg6+zlkaxCzBZfUPoQIOKLZWP6RDlU='
WHERE
key_id = '9ccecbae0c60f7a42098c40b94a0c072a43153aece3fe2b63e1fbb8243e5c10e'
AND (
token = '1yjOvIxUJHD5qJg6+zlkaxCzBZfUPoQIOKLZWP6RDlU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)