UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1BUj+JnS787HIb3qnbJ+NWMFPrZQ7pX3YetMyS3Ac00='
WHERE
key_id = 'd1ee3d4aa3d61f33caa53210953b33a623a1642fc255ae5b43077c78002fa24a'
AND (
token = '1BUj+JnS787HIb3qnbJ+NWMFPrZQ7pX3YetMyS3Ac00='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)