UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dkQ3VGN7M0J1kdjjj/6OX7Q3gopAVwRnjZIk0CZrlg4='
WHERE
key_id = '3f1493e6d20ac02bbb969e4da4d2c55cecf1008b077c078516f03f314eb94edf'
AND (
token = 'dkQ3VGN7M0J1kdjjj/6OX7Q3gopAVwRnjZIk0CZrlg4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)