UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r5flVS69x8Fr2EA1uKgnBdDbZY0m300CJpen7FSHxS8='
WHERE
key_id = '3adae39c16816047781ecab28e517068d60a9e9fb12453f211a9e9b7f7cbb8d4'
AND (
token = 'r5flVS69x8Fr2EA1uKgnBdDbZY0m300CJpen7FSHxS8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)