UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lMBkz3mwEHszBeODc1bFVet35PDlabRCegE/buinMFQ='
WHERE
key_id = '3e6f3a06d348605da4322df7c0502135f7adc52e0a66b2803b8f0ce3bfd74c4e'
AND (
token = 'lMBkz3mwEHszBeODc1bFVet35PDlabRCegE/buinMFQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)