UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7fq27mkAgHTKfk1sobUvzku6f57AChBBY7kfaoLgnLY='
WHERE
key_id = '3ca27947b1de02c88080e649dc7ac31eafd78ecf73bf404834a80761f4d64a67'
AND (
token = '7fq27mkAgHTKfk1sobUvzku6f57AChBBY7kfaoLgnLY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)