UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KrV2zS8XAZFWwhEnMpSzYCjlmnnmmqcZpXzp8Mjy1yc='
WHERE
key_id = 'e55b71384d212a524b20f4f4c82be58e473a79cc45c74f896f32ddaa7cf81e2a'
AND (
token = 'KrV2zS8XAZFWwhEnMpSzYCjlmnnmmqcZpXzp8Mjy1yc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)