UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/vgJwwEj8NnXhMktDjKguikSxSDl8OCY6B1ZmJCww8E='
WHERE
key_id = '5bbe469b812ca18720b0fe9121b44fa2841268b9a3daddb26420e1ab47e22de8'
AND (
token = '/vgJwwEj8NnXhMktDjKguikSxSDl8OCY6B1ZmJCww8E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)