UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hR2g3Ml51ANW62nj5hzl9gR8EnJIoAIgBWjbZLreCUo='
WHERE
key_id = 'a3140c2b970af592354113c03d2fed29158fc863da6d629d114efee52b06f951'
AND (
token = 'hR2g3Ml51ANW62nj5hzl9gR8EnJIoAIgBWjbZLreCUo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)