UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0z3lZ7HzRorCegb28IYFR4G6I57+Yz6k8+OPK71bJ5U='
WHERE
key_id = '0b93aeaee6ebc3105209fcaad08bd764a47d6a3705a6cc66017e1d192802c805'
AND (
token = '0z3lZ7HzRorCegb28IYFR4G6I57+Yz6k8+OPK71bJ5U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)