UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8eizPYLqi2XIi7eZmmxQop3VVA1F+NFnFac128uoTP8='
WHERE
key_id = 'b91b51152c8e8fb16801a96f60b6e24e3930b7ce238b2616771505217ac4c41c'
AND (
token = '8eizPYLqi2XIi7eZmmxQop3VVA1F+NFnFac128uoTP8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)