UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6PG7HuOOPOId9LmgZ6uaY8Ur96DC7hJTqzYAsWX+D/M='
WHERE
key_id = '5fc3c7e8547c14fc8e1f881f90735299928c71e5c0b3cb036b3c8e6ddddcd47b'
AND (
token = '6PG7HuOOPOId9LmgZ6uaY8Ur96DC7hJTqzYAsWX+D/M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)