UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k2nQPzG8C0m+blJu0f4unIsZy0bQjlkJUfyVcabVWhU='
WHERE
key_id = 'bd1735c33bb9ece1a73a94ed6b05b9583c2c2a543692474e48677a0884e1f1b7'
AND (
token = 'k2nQPzG8C0m+blJu0f4unIsZy0bQjlkJUfyVcabVWhU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)