UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I0d5AEWzzH+owzyz1DmZvtdUXrTND6oZLVew7B4n9wM='
WHERE
key_id = '2c42baf2e1a86fc137faf56bf50ef640a5ec48f457f4a7363f2a59dacf144c50'
AND (
token = 'I0d5AEWzzH+owzyz1DmZvtdUXrTND6oZLVew7B4n9wM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)