UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g31+YiA5xR4zWvEpyrhckTafjRFDl4YzDhGBjUn0PpI='
WHERE
key_id = 'd99e8d52e512e6a00d5901ef5bbdff8d96eaf2053ce1ddf042ef7c2314c9e488'
AND (
token = 'g31+YiA5xR4zWvEpyrhckTafjRFDl4YzDhGBjUn0PpI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)