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