UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8CEcb5ti+xfiv7t+peBDxUlERi0HpYyAwzOa+P5yGV0='
WHERE
key_id = 'ad7c961f91c319f1f160f55c66f30aa155e778b85722208ad67d0ee2be8cd108'
AND (
token = '8CEcb5ti+xfiv7t+peBDxUlERi0HpYyAwzOa+P5yGV0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)