UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'awW1U5GSa/vMQDUEUj7ESobSMfCkgwINIFK8BJyg7NQ='
WHERE
key_id = 'e792b9b0e7b1b9bad31cbb2f29b5f6989f7d0fd70df21f5d12f7128df5f55722'
AND (
token = 'awW1U5GSa/vMQDUEUj7ESobSMfCkgwINIFK8BJyg7NQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)