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