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