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