UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X1YkTSX7lr2Pc3O+4eck05+ZPh5nLlN6jJeVeXhpVo4='
WHERE
key_id = 'bfa4ca481389c1a108f878fbe6bfd251ce3bad5bc61cfaddb8abe39aab88a7ce'
AND (
token = 'X1YkTSX7lr2Pc3O+4eck05+ZPh5nLlN6jJeVeXhpVo4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)